Making Smart Storage Decisions for DB2 in a Flash and SSD World
نویسندگان
چکیده
This IBM® RedpaperTM publication provides a brief review of storage hard technology and the latest innovation in flash technology. It explains how solid-state drives (SSD) and High-Performance Flash Enclosures (HPFE) can contribute to the performance improvements of DB2 applications. It then provides a guide through disk configuration alternatives, which include Flash, SSDs, and spinning disks. It also explains how automated storage tiering, such as IBM Easy Tier®, can use the cost of flash storage to provide high value at minimal cost. This paper helps you to understand how performance improvements of storage technology can translate into better application performance by using IBM integration of hardware and software functions. The audience for this paper is anyone interested in the relationship between DB2 and storage performance and anyone who is looking for advice on deploying IBM storage advancements in DB2 environments.
منابع مشابه
Faster DB2 Performance with IBM FlashSystem
I/O performance is critical to DB2 operations. Although you can improve performance by using faster processors, faster systems, and advanced DB2 capabilities, data must still be read from and written to storage. Traditional hard disk drive (HDD) storage cannot provide the speed that is required by many applications. Many solid-state device (SSD) solutions add latency because software is require...
متن کاملQuery Processing on Smart SSDs
Data storage devices are getting smarter. Smart flash storage devices (a.k.a. Smart SSDs) are on the horizon and package a small programmable computer inside the device. Thus, users can run code closer to the data right inside the SSD, on the “other” side of the I/O bus. The focus of this paper is on exploring the opportunities and challenges associated with exploiting this functionality of Sma...
متن کاملLeveraging Value Locality in Optimizing NAND Flash-based SSDs
NAND flash-based solid-state drives (SSDs) are increasingly being deployed in storage systems at different levels such as buffer-caches and even secondary storage. However, the poor reliability and performance offered by these SSDs for write-intensive workloads continues to be their key shortcoming. Several solutions based on traditionally popular notions of temporal and spatial locality help r...
متن کاملF2FS: A New File System for Flash Storage
F2FS is a Linux file system designed to perform well on modern flash storage devices. The file system builds on append-only logging and its key design decisions were made with the characteristics of flash storage in mind. This paper describes the main design ideas, data structures, algorithms and the resulting performance of F2FS. Experimental results highlight the desirable performance of F2FS...
متن کاملDo Query Optimizers Need to be SSD-aware?
Flash-based solid state disks (SSDs) are beginning to supplant conventional rotating disks for performance-critical data in myriad DBMS applications, including decision support systems. Though SSDs provide the same block-oriented storage abstraction as conventional disks, their performance characteristics differ drastically. Whereas SSDs provide relatively modest improvements in sequential tran...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2014